package lily.phs.object;

import lily.phs.database.Constants;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.net.Uri;


public class HealthTest implements Constants{
	
	private Context mContext;
	
	private int hete_profileid=-1;//档案编号
	private int hete_testid=-1;//第几次体检
	private String hete_date="";
	private String hete_doctor="";
	private String hete_symptom="";
	private String hete_symptom_other="";
	private float hete_body_temperature=-1f;
	private int hete_pulse_rate=-1;
	private int hete_respiratory_rate=-1;
	private int hete_bloodpressure_left_high=-1;
	private int hete_bloodpressure_left_low=-1;
	private int hete_bloodpressure_right_high=-1;
	private int hete_bloodpressure_right_low=-1;
	private int hete_height=-1;
	private float hete_weight=-1f;
	private int hete_waistline=-1;
	private float hete_bmt=-1f;
	private int hete_olds_health=-1;
	private int hete_olds_selfcare=-1;
	private int hete_olds_cognition=-1;
	private int hete_olds_intelligence=-1;
	private int hete_olds_emotion=-1;
	private int hete_olds_depression=-1;
	private int hete_exercise_fq=-1;
	private int hete_exercise_per_time=-1;
	private int hete_exercise_lastlong=-1;
	private String hete_exercise_method="";
	private String hete_diet_habit="";
	private int hete_smoke=-1;
	private int hete_smoke_per_day=-1;
	private int hete_smoke_startage=-1;
	private int hete_smoke_quitage=-1;
	private int hete_drink_fq=-1;
	
	private float hete_drink_per_day=-1f;
	private int hete_is_abstinent=-1;
	private int hete_abstent_age=-1;
	private int hete_drink_startage=-1;
	private int hete_recent_alcoholism=-1;
	private String hete_drink_sorts="";
	private String hete_drink_other_sort="";
	private int hete_has_occupational_hazards=-1;
	private String hete_occupation="";
	private int hete_work_time=-1;
	private String hete_dust="";
	private int hete_dust_has_defence=-1;
	private String hete_dust_defence="";
	private String hete_radiation="";
	private int hete_radiation_has_defence=-1;
	private String hete_radiaiton_defence="";
	private String hete_physics="";
	private int hete_physics_has_defence=-1;
	private String hete_physics_defence="";
	private String hete_chemistry="";
	private int hete_chemistry_has_defence=-1;
	private String hete_chemistry_defence="";
	private String hete_other_toxic="";
	private int hete_other_toxic_has_defence=-1;
	private String hete_other_toxic_defence="";
	private int hete_lips=-1;
	private int hete_teeth=-1;
	private int hete_throat=-1;
	private float hete_eyesight_left=-1f;
	private float hete_eyesight_right=-1f;
	private float hete_correct_eyesight_left=-1f;
	private float hete_correct_eyesight_right=-1f;
	private int hete_hearing=-1;
	private int hete_motion_funtion=-1;
	private int hete_eyeground_isnormal=-1;
	private String hete_eyeground_abnormal="";
	private int hete_skin=-1;
	private String hete_skin_other="";
	private int hete_sclera=-1;
	private String hete_sclera_other="";
	private int hete_lymphnode=-1;
	private String hete_lymphnode_other="";
	private int hete_barrelchest=-1;
	private int hete_breathsound_isnormal=-1;
	private String hete_breathsound_abnormal="";
	private int hete_rale=-1;
	private String hete_rale_other="";
	private int hete_heartrate=-1;
	private int hete_heart_rhythm=-1;
	private int hete_has_heart_murmurs=-1;
	private String hete_heart_murmurs="";
	
	
	
	
	private int hete_has_tenderness=-1;
	private String hete_tenderness="";
	private int hete_has_mess=-1;
	private String hete_mess="";
	private int hete_has_hepatomegalia=-1;
	private String hete_hepatomegalia="";
	private int hete_has_splenoma=-1;
	private String hete_splenoma="";
	private int hete_has_shifting_dullness=-1;
	private String hete_shifting_dullness="";
	private int hete_lowerlimb_edema=-1;
	private int hete_dorsalfoot_artetial_pulse=-1;
	private int hete_anus=-1;
	private String hete_anus_other="";
	private String hete_mammary_gland="";
	private String hete_mammary_gland_other="";
	private int hete_vulva=-1;
	private String hete_vulva_abnormal="";
	private int hete_vagina=-1;
	private String hete_vagina_abnormal="";
	private int hete_cervix=-1;
	private String hete_cervix_abnormal="";
	private int hete_palace=-1;
	private String hete_palace_abnormal="";
	private int hete_appendix=-1;
	private String hete_appendix_abnormal="";
	private String hete_bodycheck_other="";
	private float hete_hemoglobin=-1f;
	private float hete_wbc=-1f;
	private float hete_blood_platelet=-1f;
	private float hete_blood_other=-1f;
	private float hete_pro=-1f;
	private float hete_glu=-1f;
	private float hete_urine_ketone=-1f;
	private float hete_bld=-1f;
	private float hete_urine_other=-1f;
	private float hete_fbs1=-1f;
	private float hete_fbs2=-1f;
	private int hete_ecg=-1;
	private String hete_ecg_abnormal="";
	private float hete_uae=-1f;
	private int hete_fecal_occult_blood=-1;
	private float hete_ghb=-1f;
	
	private int hete_hbsab=-1;
	private float hete_serum_cpt=-1f;
	private float hete_serum_ast=-1f;
	private float hete_albumin=-1f;
	private float hete_tbil=-1f;
	private float hete_dbil=-1f;
	private float hete_serum_creatinine=-1f;
	private float hete_bun=-1f;
	private float hete_blood_k_chroma=-1f;
	private float hete_blood_na_chroma=-1f;
	private float hete_tc=-1f;
	private float hete_trig=-1f;
	private float hete_serum_ldlc=-1f;
	private float hete_serum_hdlc=-1f;
	private int hete_chest_x=-1;
	private String hete_chest_x_abnormal="";
	private int hete_brightness_mode=-1;
	private String hete_brightness_mode_abnormal="";
	private int hete_cervical_smear=-1;
	private String hete_cervical_smear_abnormal="";
	private String hete_assitest_other="";
	private int hete_quality_pinghe=-1;
	private int hete_quality_qixu=-1;
	private int hete_quality_yangxu=-1;
	private int hete_quality_yinxu=-1;
	private int hete_quality_tanshi=-1;
	private int hete_quality_shire=-1;
	private int hete_quality_xueyu=-1;
	private int hete_quality_qiyu=-1;
	private int hete_quality_tebing=-1;
	
	private String hete_cerebrovascul="";
	private String hete_cerebrovascul_other="";
	private String hete_kidney_disease="";
	private String hete_kidney_disease_other="";
	private String hete_heart_disease="";
	private String hete_heart_disease_other="";
	private String hete_vascular_disease="";
	private String hete_vascular_disease_other="";
	private String hete_eye_disease="";
	private String hete_eye_disease_other="";
	private int hete_has_neur_disease=-1;
	private String hete_neur_disease="";
	private int hete_has_other_system_disease=-1;
	private String hete_other_system_disease="";
	
	private int hete_ishealthtest_normal=-1;
	private String hete_healthtest_abnormal="";
	private String hete_healthguide="";
	private String hete_hazard_control="";
	private String hete_goal_of_lose_weight="";
	private String hete_advical_vaccine="";
	private String hete_other_hazard="";
	
	public HealthTest(Context context){
		this.mContext = context;
	}
	
	
	public int getHete_profileid() {
		return hete_profileid;
	}


	public void setHete_profileid(int hete_profileid) {
		this.hete_profileid = hete_profileid;
	}


	public int getHete_testid() {
		return hete_testid;
	}


	public void setHete_testid(int hete_testid) {
		this.hete_testid = hete_testid;
	}


	public String getHete_date() {
		return hete_date;
	}
	public void setHete_date(String hete_date) {
		this.hete_date = hete_date;
	}
	public String getHete_doctor() {
		return hete_doctor;
	}
	public void setHete_doctor(String hete_doctor) {
		this.hete_doctor = hete_doctor;
	}
	public String getHete_symptom() {
		return hete_symptom;
	}
	public void setHete_symptom(String hete_symptom) {
		this.hete_symptom = hete_symptom;
	}
	public String getHete_symptom_other() {
		return hete_symptom_other;
	}
	public void setHete_symptom_other(String hete_symptom_other) {
		this.hete_symptom_other = hete_symptom_other;
	}
	public float getHete_body_temperature() {
		return hete_body_temperature;
	}
	public void setHete_body_temperature(float hete_body_temperature) {
		this.hete_body_temperature = hete_body_temperature;
	}
	public int getHete_pulse_rate() {
		return hete_pulse_rate;
	}
	public void setHete_pulse_rate(int hete_pulse_rate) {
		this.hete_pulse_rate = hete_pulse_rate;
	}
	public int getHete_respiratory_rate() {
		return hete_respiratory_rate;
	}
	public void setHete_respiratory_rate(int hete_respiratory_rate) {
		this.hete_respiratory_rate = hete_respiratory_rate;
	}
	public int getHete_bloodpressure_left_high() {
		return hete_bloodpressure_left_high;
	}
	public void setHete_bloodpressure_left_high(int hete_bloodpressure_left_high) {
		this.hete_bloodpressure_left_high = hete_bloodpressure_left_high;
	}
	public int getHete_bloodpressure_left_low() {
		return hete_bloodpressure_left_low;
	}
	public void setHete_bloodpressure_left_low(int hete_bloodpressure_left_low) {
		this.hete_bloodpressure_left_low = hete_bloodpressure_left_low;
	}
	public int getHete_bloodpressure_right_high() {
		return hete_bloodpressure_right_high;
	}
	public void setHete_bloodpressure_right_high(int hete_bloodpressure_right_high) {
		this.hete_bloodpressure_right_high = hete_bloodpressure_right_high;
	}
	public int getHete_bloodpressure_right_low() {
		return hete_bloodpressure_right_low;
	}
	public void setHete_bloodpressure_right_low(int hete_bloodpressure_right_low) {
		this.hete_bloodpressure_right_low = hete_bloodpressure_right_low;
	}
	public int getHete_height() {
		return hete_height;
	}
	public void setHete_height(int hete_height) {
		this.hete_height = hete_height;
	}
	public float getHete_weight() {
		return hete_weight;
	}
	public void setHete_weight(float hete_weight) {
		this.hete_weight = hete_weight;
	}
	public int getHete_waistline() {
		return hete_waistline;
	}
	public void setHete_waistline(int hete_waistline) {
		this.hete_waistline = hete_waistline;
	}
	public float getHete_bmt() {
		return hete_bmt;
	}
	public void setHete_bmt(float hete_bmt) {
		this.hete_bmt = hete_bmt;
	}
	public int getHete_olds_health() {
		return hete_olds_health;
	}
	public void setHete_olds_health(int hete_olds_health) {
		this.hete_olds_health = hete_olds_health;
	}
	public int getHete_olds_selfcare() {
		return hete_olds_selfcare;
	}
	public void setHete_olds_selfcare(int hete_olds_selfcare) {
		this.hete_olds_selfcare = hete_olds_selfcare;
	}
	public int getHete_olds_cognition() {
		return hete_olds_cognition;
	}
	public void setHete_olds_cognition(int hete_olds_cognition) {
		this.hete_olds_cognition = hete_olds_cognition;
	}
	public int getHete_olds_intelligence() {
		return hete_olds_intelligence;
	}
	public void setHete_olds_intelligence(int hete_olds_intelligence) {
		this.hete_olds_intelligence = hete_olds_intelligence;
	}
	public int getHete_olds_emotion() {
		return hete_olds_emotion;
	}
	public void setHete_olds_emotion(int hete_olds_emotion) {
		this.hete_olds_emotion = hete_olds_emotion;
	}
	public int getHete_olds_depression() {
		return hete_olds_depression;
	}
	public void setHete_olds_depression(int hete_olds_depression) {
		this.hete_olds_depression = hete_olds_depression;
	}
	public int getHete_exercise_fq() {
		return hete_exercise_fq;
	}
	public void setHete_exercise_fq(int hete_exercise_fq) {
		this.hete_exercise_fq = hete_exercise_fq;
	}
	public int getHete_exercise_per_time() {
		return hete_exercise_per_time;
	}
	public void setHete_exercise_per_time(int hete_exercise_per_time) {
		this.hete_exercise_per_time = hete_exercise_per_time;
	}
	public int getHete_exercise_lastlong() {
		return hete_exercise_lastlong;
	}
	public void setHete_exercise_lastlong(int hete_exercise_lastlong) {
		this.hete_exercise_lastlong = hete_exercise_lastlong;
	}
	public String getHete_exercise_method() {
		return hete_exercise_method;
	}
	public void setHete_exercise_method(String hete_exercise_method) {
		this.hete_exercise_method = hete_exercise_method;
	}
	public String getHete_diet_habit() {
		return hete_diet_habit;
	}
	public void setHete_diet_habit(String hete_diet_habit) {
		this.hete_diet_habit = hete_diet_habit;
	}
	public int getHete_smoke() {
		return hete_smoke;
	}
	public void setHete_smoke(int hete_smoke) {
		this.hete_smoke = hete_smoke;
	}
	public int getHete_smoke_per_day() {
		return hete_smoke_per_day;
	}
	public void setHete_smoke_per_day(int hete_smoke_per_day) {
		this.hete_smoke_per_day = hete_smoke_per_day;
	}
	public int getHete_smoke_startage() {
		return hete_smoke_startage;
	}
	public void setHete_smoke_startage(int hete_smoke_startage) {
		this.hete_smoke_startage = hete_smoke_startage;
	}
	public int getHete_smoke_quitage() {
		return hete_smoke_quitage;
	}

	public void setHete_smoke_quitage(int hete_smoke_quitage) {
		this.hete_smoke_quitage = hete_smoke_quitage;
	}
	public int getHete_drink_fq() {
		return hete_drink_fq;
	}
	public void setHete_drink_fq(int hete_drink_fq) {
		this.hete_drink_fq = hete_drink_fq;
	}
	public float getHete_drink_per_day() {
		return hete_drink_per_day;
	}
	public void setHete_drink_per_day(float hete_drink_per_day) {
		this.hete_drink_per_day = hete_drink_per_day;
	}
	public int getHete_is_abstinent() {
		return hete_is_abstinent;
	}
	public void setHete_is_abstinent(int hete_is_abstinent) {
		this.hete_is_abstinent = hete_is_abstinent;
	}
	public int getHete_abstent_age() {
		return hete_abstent_age;
	}
	public void setHete_abstent_age(int hete_abstent_age) {
		this.hete_abstent_age = hete_abstent_age;
	}
	public int getHete_drink_startage() {
		return hete_drink_startage;
	}
	public void setHete_drink_startage(int hete_drink_startage) {
		this.hete_drink_startage = hete_drink_startage;
	}
	public int getHete_recent_alcoholism() {
		return hete_recent_alcoholism;
	}
	public void setHete_recent_alcoholism(int hete_recent_alcoholism) {
		this.hete_recent_alcoholism = hete_recent_alcoholism;
	}
	public String getHete_drink_sorts() {
		return hete_drink_sorts;
	}
	public void setHete_drink_sorts(String hete_drink_sorts) {
		this.hete_drink_sorts = hete_drink_sorts;
	}
	public String getHete_drink_other_sort() {
		return hete_drink_other_sort;
	}
	public void setHete_drink_other_sort(String hete_drink_other_sort) {
		this.hete_drink_other_sort = hete_drink_other_sort;
	}
	public int getHete_has_occupational_hazards() {
		return hete_has_occupational_hazards;
	}
	public void setHete_has_occupational_hazards(int hete_has_occupational_hazards) {
		this.hete_has_occupational_hazards = hete_has_occupational_hazards;
	}
	public String getHete_occupation() {
		return hete_occupation;
	}
	public void setHete_occupation(String hete_occupation) {
		this.hete_occupation = hete_occupation;
	}
	public int getHete_work_time() {
		return hete_work_time;
	}
	public void setHete_work_time(int hete_work_time) {
		this.hete_work_time = hete_work_time;
	}
	public String getHete_dust() {
		return hete_dust;
	}
	public void setHete_dust(String hete_dust) {
		this.hete_dust = hete_dust;
	}
	public int getHete_dust_has_defence() {
		return hete_dust_has_defence;
	}
	public void setHete_dust_has_defence(int hete_dust_has_defence) {
		this.hete_dust_has_defence = hete_dust_has_defence;
	}
	public String getHete_dust_defence() {
		return hete_dust_defence;
	}
	public void setHete_dust_defence(String hete_dust_defence) {
		this.hete_dust_defence = hete_dust_defence;
	}
	public String getHete_radiation() {
		return hete_radiation;
	}
	public void setHete_radiation(String hete_radiation) {
		this.hete_radiation = hete_radiation;
	}
	public int getHete_radiation_has_defence() {
		return hete_radiation_has_defence;
	}
	public void setHete_radiation_has_defence(int hete_radiation_has_defence) {
		this.hete_radiation_has_defence = hete_radiation_has_defence;
	}
	public String getHete_radiaiton_defence() {
		return hete_radiaiton_defence;
	}
	public void setHete_radiaiton_defence(String hete_radiaiton_defence) {
		this.hete_radiaiton_defence = hete_radiaiton_defence;
	}
	public String getHete_physics() {
		return hete_physics;
	}
	public void setHete_physics(String hete_physics) {
		this.hete_physics = hete_physics;
	}
	public int getHete_physics_has_defence() {
		return hete_physics_has_defence;
	}
	public void setHete_physics_has_defence(int hete_physics_has_defence) {
		this.hete_physics_has_defence = hete_physics_has_defence;
	}
	public String getHete_physics_defence() {
		return hete_physics_defence;
	}
	public void setHete_physics_defence(String hete_physics_defence) {
		this.hete_physics_defence = hete_physics_defence;
	}
	public String getHete_chemistry() {
		return hete_chemistry;
	}
	public void setHete_chemistry(String hete_chemistry) {
		this.hete_chemistry = hete_chemistry;
	}
	public int getHete_chemistry_has_defence() {
		return hete_chemistry_has_defence;
	}
	public void setHete_chemistry_has_defence(int hete_chemistry_has_defence) {
		this.hete_chemistry_has_defence = hete_chemistry_has_defence;
	}
	public String getHete_chemistry_defence() {
		return hete_chemistry_defence;
	}
	public void setHete_chemistry_defence(String hete_chemistry_defence) {
		this.hete_chemistry_defence = hete_chemistry_defence;
	}
	public String getHete_other_toxic() {
		return hete_other_toxic;
	}
	public void setHete_other_toxic(String hete_other_toxic) {
		this.hete_other_toxic = hete_other_toxic;
	}
	public int getHete_other_toxic_has_defence() {
		return hete_other_toxic_has_defence;
	}
	public void setHete_other_toxic_has_defence(int hete_other_toxic_has_defence) {
		this.hete_other_toxic_has_defence = hete_other_toxic_has_defence;
	}
	public String getHete_other_toxic_defence() {
		return hete_other_toxic_defence;
	}
	public void setHete_other_toxic_defence(String hete_other_toxic_defence) {
		this.hete_other_toxic_defence = hete_other_toxic_defence;
	}
	public int getHete_lips() {
		return hete_lips;
	}
	public void setHete_lips(int hete_lips) {
		this.hete_lips = hete_lips;
	}
	public int getHete_teeth() {
		return hete_teeth;
	}
	public void setHete_teeth(int hete_teeth) {
		this.hete_teeth = hete_teeth;
	}
	public int getHete_throat() {
		return hete_throat;
	}
	public void setHete_throat(int hete_throat) {
		this.hete_throat = hete_throat;
	}
	public float getHete_eyesight_left() {
		return hete_eyesight_left;
	}
	public void setHete_eyesight_left(float hete_eyesight_left) {
		this.hete_eyesight_left = hete_eyesight_left;
	}
	public float getHete_eyesight_right() {
		return hete_eyesight_right;
	}
	public void setHete_eyesight_right(float hete_eyesight_right) {
		this.hete_eyesight_right = hete_eyesight_right;
	}
	public float getHete_correct_eyesight_left() {
		return hete_correct_eyesight_left;
	}
	public void setHete_correct_eyesight_left(float hete_correct_eyesight_left) {
		this.hete_correct_eyesight_left = hete_correct_eyesight_left;
	}
	public float getHete_correct_eyesight_right() {
		return hete_correct_eyesight_right;
	}
	public void setHete_correct_eyesight_right(float hete_correct_eyesight_right) {
		this.hete_correct_eyesight_right = hete_correct_eyesight_right;
	}
	public int getHete_hearing() {
		return hete_hearing;
	}
	public void setHete_hearing(int hete_hearing) {
		this.hete_hearing = hete_hearing;
	}
	public int getHete_motion_funtion() {
		return hete_motion_funtion;
	}
	public void setHete_motion_funtion(int hete_motion_funtion) {
		this.hete_motion_funtion = hete_motion_funtion;
	}
	public int getHete_eyeground_isnormal() {
		return hete_eyeground_isnormal;
	}
	public void setHete_eyeground_isnormal(int hete_eyeground_isnormal) {
		this.hete_eyeground_isnormal = hete_eyeground_isnormal;
	}
	public String getHete_eyeground_abnormal() {
		return hete_eyeground_abnormal;
	}
	public void setHete_eyeground_abnormal(String hete_eyeground_abnormal) {
		this.hete_eyeground_abnormal = hete_eyeground_abnormal;
	}
	public int getHete_skin() {
		return hete_skin;
	}
	public void setHete_skin(int hete_skin) {
		this.hete_skin = hete_skin;
	}
	public String getHete_skin_other() {
		return hete_skin_other;
	}
	public void setHete_skin_other(String hete_skin_other) {
		this.hete_skin_other = hete_skin_other;
	}
	public int getHete_sclera() {
		return hete_sclera;
	}
	public void setHete_sclera(int hete_sclera) {
		this.hete_sclera = hete_sclera;
	}
	public String getHete_sclera_other() {
		return hete_sclera_other;
	}
	public void setHete_sclera_other(String hete_sclera_other) {
		this.hete_sclera_other = hete_sclera_other;
	}
	public int getHete_lymphnode() {
		return hete_lymphnode;
	}
	public void setHete_lymphnode(int hete_lymphnode) {
		this.hete_lymphnode = hete_lymphnode;
	}
	public String getHete_lymphnode_other() {
		return hete_lymphnode_other;
	}
	public void setHete_lymphnode_other(String hete_lymphnode_other) {
		this.hete_lymphnode_other = hete_lymphnode_other;
	}
	public int getHete_barrelchest() {
		return hete_barrelchest;
	}
	public void setHete_barrelchest(int hete_barrelchest) {
		this.hete_barrelchest = hete_barrelchest;
	}
	public int getHete_breathsound_isnormal() {
		return hete_breathsound_isnormal;
	}
	public void setHete_breathsound_isnormal(int hete_breathsound_isnormal) {
		this.hete_breathsound_isnormal = hete_breathsound_isnormal;
	}
	public String getHete_breathsound_abnormal() {
		return hete_breathsound_abnormal;
	}
	public void setHete_breathsound_abnormal(String hete_breathsound_abnormal) {
		this.hete_breathsound_abnormal = hete_breathsound_abnormal;
	}
	public int getHete_rale() {
		return hete_rale;
	}
	public void setHete_rale(int hete_rale) {
		this.hete_rale = hete_rale;
	}
	public String getHete_rale_other() {
		return hete_rale_other;
	}
	public void setHete_rale_other(String hete_rale_other) {
		this.hete_rale_other = hete_rale_other;
	}
	public int getHete_heartrate() {
		return hete_heartrate;
	}
	public void setHete_heartrate(int hete_heartrate) {
		this.hete_heartrate = hete_heartrate;
	}
	public int getHete_heart_rhythm() {
		return hete_heart_rhythm;
	}
	public void setHete_heart_rhythm(int hete_heart_rhythm) {
		this.hete_heart_rhythm = hete_heart_rhythm;
	}
	public int getHete_has_heart_murmurs() {
		return hete_has_heart_murmurs;
	}
	public void setHete_has_heart_murmurs(int hete_has_heart_murmurs) {
		this.hete_has_heart_murmurs = hete_has_heart_murmurs;
	}
	public String getHete_heart_murmurs() {
		return hete_heart_murmurs;
	}
	public void setHete_heart_murmurs(String hete_heart_murmurs) {
		this.hete_heart_murmurs = hete_heart_murmurs;
	}
	public int getHete_has_tenderness() {
		return hete_has_tenderness;
	}
	public void setHete_has_tenderness(int hete_has_tenderness) {
		this.hete_has_tenderness = hete_has_tenderness;
	}
	public String getHete_tenderness() {
		return hete_tenderness;
	}
	public void setHete_tenderness(String hete_tenderness) {
		this.hete_tenderness = hete_tenderness;
	}
	public int getHete_has_mess() {
		return hete_has_mess;
	}
	public void setHete_has_mess(int hete_has_mess) {
		this.hete_has_mess = hete_has_mess;
	}
	public String getHete_mess() {
		return hete_mess;
	}
	public void setHete_mess(String hete_mess) {
		this.hete_mess = hete_mess;
	}
	public int getHete_has_hepatomegalia() {
		return hete_has_hepatomegalia;
	}
	public void setHete_has_hepatomegalia(int hete_has_hepatomegalia) {
		this.hete_has_hepatomegalia = hete_has_hepatomegalia;
	}
	public String getHete_hepatomegalia() {
		return hete_hepatomegalia;
	}
	public void setHete_hepatomegalia(String hete_hepatomegalia) {
		this.hete_hepatomegalia = hete_hepatomegalia;
	}
	public int getHete_has_splenoma() {
		return hete_has_splenoma;
	}
	public void setHete_has_splenoma(int hete_has_splenoma) {
		this.hete_has_splenoma = hete_has_splenoma;
	}
	public String getHete_splenoma() {
		return hete_splenoma;
	}
	public void setHete_splenoma(String hete_splenoma) {
		this.hete_splenoma = hete_splenoma;
	}
	public int getHete_has_shifting_dullness() {
		return hete_has_shifting_dullness;
	}
	public void setHete_has_shifting_dullness(int hete_has_shifting_dullness) {
		this.hete_has_shifting_dullness = hete_has_shifting_dullness;
	}
	public String getHete_shifting_dullness() {
		return hete_shifting_dullness;
	}
	public void setHete_shifting_dullness(String hete_shifting_dullness) {
		this.hete_shifting_dullness = hete_shifting_dullness;
	}
	public int getHete_lowerlimb_edema() {
		return hete_lowerlimb_edema;
	}
	public void setHete_lowerlimb_edema(int hete_lowerlimb_edema) {
		this.hete_lowerlimb_edema = hete_lowerlimb_edema;
	}
	public int getHete_dorsalfoot_artetial_pulse() {
		return hete_dorsalfoot_artetial_pulse;
	}
	public void setHete_dorsalfoot_artetial_pulse(int hete_dorsalfoot_artetial_pulse) {
		this.hete_dorsalfoot_artetial_pulse = hete_dorsalfoot_artetial_pulse;
	}
	public int getHete_anus() {
		return hete_anus;
	}
	public void setHete_anus(int hete_anus) {
		this.hete_anus = hete_anus;
	}
	public String getHete_anus_other() {
		return hete_anus_other;
	}
	public void setHete_anus_other(String hete_anus_other) {
		this.hete_anus_other = hete_anus_other;
	}
	public String getHete_mammary_gland() {
		return hete_mammary_gland;
	}
	public void setHete_mammary_gland(String hete_mammary_gland) {
		this.hete_mammary_gland = hete_mammary_gland;
	}
	public String getHete_mammary_gland_other() {
		return hete_mammary_gland_other;
	}
	public void setHete_mammary_gland_other(String hete_mammary_gland_other) {
		this.hete_mammary_gland_other = hete_mammary_gland_other;
	}
	public int getHete_vulva() {
		return hete_vulva;
	}
	public void setHete_vulva(int hete_vulva) {
		this.hete_vulva = hete_vulva;
	}
	public String getHete_vulva_abnormal() {
		return hete_vulva_abnormal;
	}
	public void setHete_vulva_abnormal(String hete_vulva_abnormal) {
		this.hete_vulva_abnormal = hete_vulva_abnormal;
	}
	public int getHete_vagina() {
		return hete_vagina;
	}
	public void setHete_vagina(int hete_vagina) {
		this.hete_vagina = hete_vagina;
	}
	public String getHete_vagina_abnormal() {
		return hete_vagina_abnormal;
	}
	public void setHete_vagina_abnormal(String hete_vagina_abnormal) {
		this.hete_vagina_abnormal = hete_vagina_abnormal;
	}
	public int getHete_cervix() {
		return hete_cervix;
	}
	public void setHete_cervix(int hete_cervix) {
		this.hete_cervix = hete_cervix;
	}
	public String getHete_cervix_abnormal() {
		return hete_cervix_abnormal;
	}
	public void setHete_cervix_abnormal(String hete_cervix_abnormal) {
		this.hete_cervix_abnormal = hete_cervix_abnormal;
	}
	public int getHete_palace() {
		return hete_palace;
	}
	public void setHete_palace(int hete_palace) {
		this.hete_palace = hete_palace;
	}
	public String getHete_palace_abnormal() {
		return hete_palace_abnormal;
	}
	public void setHete_palace_abnormal(String hete_palace_abnormal) {
		this.hete_palace_abnormal = hete_palace_abnormal;
	}
	public int getHete_appendix() {
		return hete_appendix;
	}
	public void setHete_appendix(int hete_appendix) {
		this.hete_appendix = hete_appendix;
	}
	public String getHete_appendix_abnormal() {
		return hete_appendix_abnormal;
	}
	public void setHete_appendix_abnormal(String hete_appendix_abnormal) {
		this.hete_appendix_abnormal = hete_appendix_abnormal;
	}
	public String getHete_bodycheck_other() {
		return hete_bodycheck_other;
	}
	public void setHete_bodycheck_other(String hete_bodycheck_other) {
		this.hete_bodycheck_other = hete_bodycheck_other;
	}
	public float getHete_hemoglobin() {
		return hete_hemoglobin;
	}
	public void setHete_hemoglobin(float hete_hemoglobin) {
		this.hete_hemoglobin = hete_hemoglobin;
	}
	public float getHete_wbc() {
		return hete_wbc;
	}
	public void setHete_wbc(float hete_wbc) {
		this.hete_wbc = hete_wbc;
	}
	public float getHete_blood_platelet() {
		return hete_blood_platelet;
	}
	public void setHete_blood_platelet(float hete_blood_platelet) {
		this.hete_blood_platelet = hete_blood_platelet;
	}
	public float getHete_blood_other() {
		return hete_blood_other;
	}
	public void setHete_blood_other(float hete_blood_other) {
		this.hete_blood_other = hete_blood_other;
	}
	public float getHete_pro() {
		return hete_pro;
	}
	public void setHete_pro(float hete_pro) {
		this.hete_pro = hete_pro;
	}
	public float getHete_glu() {
		return hete_glu;
	}
	public void setHete_glu(float hete_glu) {
		this.hete_glu = hete_glu;
	}
	public float getHete_urine_ketone() {
		return hete_urine_ketone;
	}
	public void setHete_urine_ketone(float hete_urine_ketone) {
		this.hete_urine_ketone = hete_urine_ketone;
	}
	public float getHete_bld() {
		return hete_bld;
	}
	public void setHete_bld(float hete_bld) {
		this.hete_bld = hete_bld;
	}
	public float getHete_urine_other() {
		return hete_urine_other;
	}
	public void setHete_urine_other(float hete_urine_other) {
		this.hete_urine_other = hete_urine_other;
	}
	public float getHete_fbs1() {
		return hete_fbs1;
	}
	public void setHete_fbs1(float hete_fbs1) {
		this.hete_fbs1 = hete_fbs1;
	}
	public float getHete_fbs2() {
		return hete_fbs2;
	}
	public void setHete_fbs2(float hete_fbs2) {
		this.hete_fbs2 = hete_fbs2;
	}
	public int getHete_ecg() {
		return hete_ecg;
	}
	public void setHete_ecg(int hete_ecg) {
		this.hete_ecg = hete_ecg;
	}
	public String getHete_ecg_abnormal() {
		return hete_ecg_abnormal;
	}
	public void setHete_ecg_abnormal(String hete_ecg_abnormal) {
		this.hete_ecg_abnormal = hete_ecg_abnormal;
	}
	public float getHete_uae() {
		return hete_uae;
	}
	public void setHete_uae(float hete_uae) {
		this.hete_uae = hete_uae;
	}
	public int getHete_fecal_occult_blood() {
		return hete_fecal_occult_blood;
	}
	public void setHete_fecal_occult_blood(int hete_fecal_occult_blood) {
		this.hete_fecal_occult_blood = hete_fecal_occult_blood;
	}
	public float getHete_ghb() {
		return hete_ghb;
	}
	public void setHete_ghb(float hete_ghb) {
		this.hete_ghb = hete_ghb;
	}
	public int getHete_hbsab() {
		return hete_hbsab;
	}
	public void setHete_hbsab(int hete_hbsab) {
		this.hete_hbsab = hete_hbsab;
	}
	public float getHete_serum_cpt() {
		return hete_serum_cpt;
	}
	public void setHete_serum_cpt(float hete_serum_cpt) {
		this.hete_serum_cpt = hete_serum_cpt;
	}
	public float getHete_serum_ast() {
		return hete_serum_ast;
	}
	public void setHete_serum_ast(float hete_serum_ast) {
		this.hete_serum_ast = hete_serum_ast;
	}
	public float getHete_albumin() {
		return hete_albumin;
	}
	public void setHete_albumin(float hete_albumin) {
		this.hete_albumin = hete_albumin;
	}
	public float getHete_tbil() {
		return hete_tbil;
	}
	public void setHete_tbil(float hete_tbil) {
		this.hete_tbil = hete_tbil;
	}
	public float getHete_dbil() {
		return hete_dbil;
	}
	public void setHete_dbil(float hete_dbil) {
		this.hete_dbil = hete_dbil;
	}
	public float getHete_serum_creatinine() {
		return hete_serum_creatinine;
	}
	public void setHete_serum_creatinine(float hete_serum_creatinine) {
		this.hete_serum_creatinine = hete_serum_creatinine;
	}
	public float getHete_bun() {
		return hete_bun;
	}
	public void setHete_bun(float hete_bun) {
		this.hete_bun = hete_bun;
	}
	public float getHete_blood_k_chroma() {
		return hete_blood_k_chroma;
	}
	public void setHete_blood_k_chroma(float hete_blood_k_chroma) {
		this.hete_blood_k_chroma = hete_blood_k_chroma;
	}
	public float getHete_blood_na_chroma() {
		return hete_blood_na_chroma;
	}
	public void setHete_blood_na_chroma(float hete_blood_na_chroma) {
		this.hete_blood_na_chroma = hete_blood_na_chroma;
	}
	public float getHete_tc() {
		return hete_tc;
	}
	public void setHete_tc(float hete_tc) {
		this.hete_tc = hete_tc;
	}
	public float getHete_trig() {
		return hete_trig;
	}
	public void setHete_trig(float hete_trig) {
		this.hete_trig = hete_trig;
	}
	public float getHete_serum_ldlc() {
		return hete_serum_ldlc;
	}
	public void setHete_serum_ldlc(float hete_serum_ldlc) {
		this.hete_serum_ldlc = hete_serum_ldlc;
	}
	public float getHete_serum_hdlc() {
		return hete_serum_hdlc;
	}
	public void setHete_serum_hdlc(float hete_serum_hdlc) {
		this.hete_serum_hdlc = hete_serum_hdlc;
	}
	public int getHete_chest_x() {
		return hete_chest_x;
	}
	public void setHete_chest_x(int hete_chest_x) {
		this.hete_chest_x = hete_chest_x;
	}
	public String getHete_chest_x_abnormal() {
		return hete_chest_x_abnormal;
	}
	public void setHete_chest_x_abnormal(String hete_chest_x_abnormal) {
		this.hete_chest_x_abnormal = hete_chest_x_abnormal;
	}
	public int getHete_brightness_mode() {
		return hete_brightness_mode;
	}
	public void setHete_brightness_mode(int hete_brightness_mode) {
		this.hete_brightness_mode = hete_brightness_mode;
	}
	public String getHete_brightness_mode_abnormal() {
		return hete_brightness_mode_abnormal;
	}
	public void setHete_brightness_mode_abnormal(
			String hete_brightness_mode_abnormal) {
		this.hete_brightness_mode_abnormal = hete_brightness_mode_abnormal;
	}
	public int getHete_cervical_smear() {
		return hete_cervical_smear;
	}
	public void setHete_cervical_smear(int hete_cervical_smear) {
		this.hete_cervical_smear = hete_cervical_smear;
	}
	public String getHete_cervical_smear_abnormal() {
		return hete_cervical_smear_abnormal;
	}
	public void setHete_cervical_smear_abnormal(String hete_cervical_smear_abnormal) {
		this.hete_cervical_smear_abnormal = hete_cervical_smear_abnormal;
	}
	public String getHete_assitest_other() {
		return hete_assitest_other;
	}
	public void setHete_assitest_other(String hete_assitest_other) {
		this.hete_assitest_other = hete_assitest_other;
	}
	public int getHete_quality_pinghe() {
		return hete_quality_pinghe;
	}
	public void setHete_quality_pinghe(int hete_quality_pinghe) {
		this.hete_quality_pinghe = hete_quality_pinghe;
	}
	public int getHete_quality_qixu() {
		return hete_quality_qixu;
	}
	public void setHete_quality_qixu(int hete_quality_qixu) {
		this.hete_quality_qixu = hete_quality_qixu;
	}
	public int getHete_quality_yangxu() {
		return hete_quality_yangxu;
	}
	public void setHete_quality_yangxu(int hete_quality_yangxu) {
		this.hete_quality_yangxu = hete_quality_yangxu;
	}
	public int getHete_quality_yinxu() {
		return hete_quality_yinxu;
	}
	public void setHete_quality_yinxu(int hete_quality_yinxu) {
		this.hete_quality_yinxu = hete_quality_yinxu;
	}
	public int getHete_quality_tanshi() {
		return hete_quality_tanshi;
	}
	public void setHete_quality_tanshi(int hete_quality_tanshi) {
		this.hete_quality_tanshi = hete_quality_tanshi;
	}
	public int getHete_quality_shire() {
		return hete_quality_shire;
	}
	public void setHete_quality_shire(int hete_quality_shire) {
		this.hete_quality_shire = hete_quality_shire;
	}
	public int getHete_quality_xueyu() {
		return hete_quality_xueyu;
	}
	public void setHete_quality_xueyu(int hete_quality_xueyu) {
		this.hete_quality_xueyu = hete_quality_xueyu;
	}
	public int getHete_quality_qiyu() {
		return hete_quality_qiyu;
	}
	public void setHete_quality_qiyu(int hete_quality_qiyu) {
		this.hete_quality_qiyu = hete_quality_qiyu;
	}
	public int getHete_quality_tebing() {
		return hete_quality_tebing;
	}
	public void setHete_quality_tebing(int hete_quality_tebing) {
		this.hete_quality_tebing = hete_quality_tebing;
	}
	public String getHete_cerebrovascul() {
		return hete_cerebrovascul;
	}
	public void setHete_cerebrovascul(String hete_cerebrovascul) {
		this.hete_cerebrovascul = hete_cerebrovascul;
	}
	public String getHete_cerebrovascul_other() {
		return hete_cerebrovascul_other;
	}
	public void setHete_cerebrovascul_other(String hete_cerebrovascul_other) {
		this.hete_cerebrovascul_other = hete_cerebrovascul_other;
	}
	public String getHete_kidney_disease() {
		return hete_kidney_disease;
	}
	public void setHete_kidney_disease(String hete_kidney_disease) {
		this.hete_kidney_disease = hete_kidney_disease;
	}
	public String getHete_kidney_disease_other() {
		return hete_kidney_disease_other;
	}
	public void setHete_kidney_disease_other(String hete_kidney_disease_other) {
		this.hete_kidney_disease_other = hete_kidney_disease_other;
	}
	public String getHete_heart_disease() {
		return hete_heart_disease;
	}
	public void setHete_heart_disease(String hete_heart_disease) {
		this.hete_heart_disease = hete_heart_disease;
	}
	public String getHete_heart_disease_other() {
		return hete_heart_disease_other;
	}
	public void setHete_heart_disease_other(String hete_heart_disease_other) {
		this.hete_heart_disease_other = hete_heart_disease_other;
	}
	public String getHete_vascular_disease() {
		return hete_vascular_disease;
	}
	public void setHete_vascular_disease(String hete_vascular_disease) {
		this.hete_vascular_disease = hete_vascular_disease;
	}
	public String getHete_vascular_disease_other() {
		return hete_vascular_disease_other;
	}
	public void setHete_vascular_disease_other(String hete_vascular_disease_other) {
		this.hete_vascular_disease_other = hete_vascular_disease_other;
	}
	public String getHete_eye_disease() {
		return hete_eye_disease;
	}
	public void setHete_eye_disease(String hete_eye_disease) {
		this.hete_eye_disease = hete_eye_disease;
	}
	public String getHete_eye_disease_other() {
		return hete_eye_disease_other;
	}
	public void setHete_eye_disease_other(String hete_eye_disease_other) {
		this.hete_eye_disease_other = hete_eye_disease_other;
	}
	public int getHete_has_neur_disease() {
		return hete_has_neur_disease;
	}
	public void setHete_has_neur_disease(int hete_has_neur_disease) {
		this.hete_has_neur_disease = hete_has_neur_disease;
	}
	public String getHete_neur_disease() {
		return hete_neur_disease;
	}
	public void setHete_neur_disease(String hete_neur_disease) {
		this.hete_neur_disease = hete_neur_disease;
	}
	public int getHete_has_other_system_disease() {
		return hete_has_other_system_disease;
	}
	public void setHete_has_other_system_disease(int hete_has_other_system_disease) {
		this.hete_has_other_system_disease = hete_has_other_system_disease;
	}
	public String getHete_other_system_disease() {
		return hete_other_system_disease;
	}
	public void setHete_other_system_disease(String hete_other_system_disease) {
		this.hete_other_system_disease = hete_other_system_disease;
	}
	public int getHete_ishealthtest_normal() {
		return hete_ishealthtest_normal;
	}
	public void setHete_ishealthtest_normal(int hete_ishealthtest_normal) {
		this.hete_ishealthtest_normal = hete_ishealthtest_normal;
	}
	public String getHete_healthtest_abnormal() {
		return hete_healthtest_abnormal;
	}
	public void setHete_healthtest_abnormal(String hete_healthtest_abnormal) {
		this.hete_healthtest_abnormal = hete_healthtest_abnormal;
	}
	public String getHete_healthguide() {
		return hete_healthguide;
	}
	public void setHete_healthguide(String hete_healthguide) {
		this.hete_healthguide = hete_healthguide;
	}
	public String getHete_hazard_control() {
		return hete_hazard_control;
	}
	public void setHete_hazard_control(String hete_hazard_control) {
		this.hete_hazard_control = hete_hazard_control;
	}
	public String getHete_goal_of_lose_weight() {
		return hete_goal_of_lose_weight;
	}
	public void setHete_goal_of_lose_weight(String hete_goal_of_lose_weight) {
		this.hete_goal_of_lose_weight = hete_goal_of_lose_weight;
	}
	public String getHete_advical_vaccine() {
		return hete_advical_vaccine;
	}
	public void setHete_advical_vaccine(String hete_advical_vaccine) {
		this.hete_advical_vaccine = hete_advical_vaccine;
	}
	public String getHete_other_hazard() {
		return hete_other_hazard;
	}
	public void setHete_other_hazard(String hete_other_hazard) {
		this.hete_other_hazard = hete_other_hazard;
	}
	
	public void insertHealthTest(){
//		int result = -1;
		ContentValues value = new ContentValues();
		value.put(HETE_COLUMN1, this.getHete_profileid());
		value.put(HETE_COLUMN178, this.getHete_testid());
		value.put(HETE_COLUMN2, this.getHete_date());
		value.put(HETE_COLUMN3, this.getHete_doctor());
		value.put(HETE_COLUMN4, this.getHete_symptom());
		value.put(HETE_COLUMN5, this.getHete_symptom_other());
		value.put(HETE_COLUMN6, this.getHete_body_temperature());
		value.put(HETE_COLUMN7, this.getHete_pulse_rate());
		value.put(HETE_COLUMN8, this.getHete_respiratory_rate());
		value.put(HETE_COLUMN9, this.getHete_bloodpressure_left_high());
		value.put(HETE_COLUMN10, this.getHete_bloodpressure_left_low());
		value.put(HETE_COLUMN11, this.getHete_bloodpressure_right_high());
		value.put(HETE_COLUMN12, this.getHete_bloodpressure_right_low());
		value.put(HETE_COLUMN13, this.getHete_height());
		value.put(HETE_COLUMN14, this.getHete_weight());
		value.put(HETE_COLUMN15, this.getHete_waistline());
		value.put(HETE_COLUMN16, this.getHete_bmt());
		value.put(HETE_COLUMN17, this.getHete_olds_health());
		value.put(HETE_COLUMN18, this.getHete_olds_selfcare());
		value.put(HETE_COLUMN19, this.getHete_olds_cognition());
		value.put(HETE_COLUMN20, this.getHete_olds_intelligence());
		value.put(HETE_COLUMN21, this.getHete_olds_emotion());
		value.put(HETE_COLUMN22, this.getHete_olds_depression());
		value.put(HETE_COLUMN23, this.getHete_exercise_fq());
		value.put(HETE_COLUMN24, this.getHete_exercise_per_time());
		value.put(HETE_COLUMN25, this.getHete_exercise_lastlong());
		value.put(HETE_COLUMN26, this.getHete_exercise_method());
		value.put(HETE_COLUMN27, this.getHete_diet_habit());
		value.put(HETE_COLUMN28, this.getHete_smoke());
		value.put(HETE_COLUMN29, this.getHete_smoke_per_day());
		value.put(HETE_COLUMN30, this.getHete_smoke_startage());
		value.put(HETE_COLUMN31, this.getHete_smoke_quitage());
		value.put(HETE_COLUMN32, this.getHete_drink_fq());
		value.put(HETE_COLUMN33, this.getHete_drink_per_day());
		value.put(HETE_COLUMN34, this.getHete_is_abstinent());
		value.put(HETE_COLUMN35, this.getHete_abstent_age());
		value.put(HETE_COLUMN36, this.getHete_drink_startage());
		value.put(HETE_COLUMN37, this.getHete_recent_alcoholism());
		value.put(HETE_COLUMN38, this.getHete_drink_sorts());
		value.put(HETE_COLUMN39, this.getHete_drink_other_sort());
		value.put(HETE_COLUMN40, this.getHete_has_occupational_hazards());
		value.put(HETE_COLUMN41, this.getHete_occupation());
		value.put(HETE_COLUMN42, this.getHete_work_time());
		value.put(HETE_COLUMN43, this.getHete_dust());
		value.put(HETE_COLUMN44, this.getHete_dust_has_defence());
		value.put(HETE_COLUMN45, this.getHete_dust_defence());
		value.put(HETE_COLUMN46, this.getHete_radiation());
		value.put(HETE_COLUMN47, this.getHete_radiation_has_defence());
		value.put(HETE_COLUMN48, this.getHete_radiaiton_defence());
		value.put(HETE_COLUMN49, this.getHete_physics());
		value.put(HETE_COLUMN50, this.getHete_physics_has_defence());
		value.put(HETE_COLUMN51, this.getHete_physics_defence());
		value.put(HETE_COLUMN52, this.getHete_chemistry());
		value.put(HETE_COLUMN53, this.getHete_chemistry_has_defence());
		value.put(HETE_COLUMN54, this.getHete_chemistry_defence());
		value.put(HETE_COLUMN55, this.getHete_other_toxic());
		value.put(HETE_COLUMN56, this.getHete_other_toxic_has_defence());
		value.put(HETE_COLUMN57, this.getHete_other_toxic_defence());
		value.put(HETE_COLUMN58, this.getHete_lips());
		value.put(HETE_COLUMN59, this.getHete_teeth());
		value.put(HETE_COLUMN60, this.getHete_throat());
		value.put(HETE_COLUMN61, this.getHete_eyesight_left());
		value.put(HETE_COLUMN62, this.getHete_eyesight_right());
		value.put(HETE_COLUMN63, this.getHete_correct_eyesight_left());
		value.put(HETE_COLUMN64, this.getHete_correct_eyesight_right());
		value.put(HETE_COLUMN65, this.getHete_hearing());
		value.put(HETE_COLUMN66, this.getHete_motion_funtion());
		value.put(HETE_COLUMN67, this.getHete_eyeground_isnormal());
		value.put(HETE_COLUMN68, this.getHete_eyeground_abnormal());
		value.put(HETE_COLUMN69, this.getHete_skin());
		value.put(HETE_COLUMN70, this.getHete_skin_other());
		value.put(HETE_COLUMN71, this.getHete_sclera());
		value.put(HETE_COLUMN72, this.getHete_sclera_other());
		value.put(HETE_COLUMN73, this.getHete_lymphnode());
		value.put(HETE_COLUMN74, this.getHete_lymphnode_other());
		value.put(HETE_COLUMN75, this.getHete_barrelchest());
		value.put(HETE_COLUMN76, this.getHete_breathsound_isnormal());
		value.put(HETE_COLUMN77, this.getHete_breathsound_abnormal());
		value.put(HETE_COLUMN78, this.getHete_rale());
		value.put(HETE_COLUMN79, this.getHete_rale_other());
		value.put(HETE_COLUMN80, this.getHete_heartrate());
		value.put(HETE_COLUMN81, this.getHete_heart_rhythm());
		value.put(HETE_COLUMN82, this.getHete_has_heart_murmurs());
		value.put(HETE_COLUMN83, this.getHete_heart_murmurs());
		value.put(HETE_COLUMN84, this.getHete_has_tenderness());
		value.put(HETE_COLUMN85, this.getHete_tenderness());
		value.put(HETE_COLUMN86, this.getHete_has_mess());
		value.put(HETE_COLUMN87, this.getHete_mess());
		value.put(HETE_COLUMN88, this.getHete_has_hepatomegalia());
		value.put(HETE_COLUMN89, this.getHete_hepatomegalia());
		value.put(HETE_COLUMN90, this.getHete_has_splenoma());
		value.put(HETE_COLUMN91, this.getHete_splenoma());
		value.put(HETE_COLUMN92, this.getHete_has_shifting_dullness());
		value.put(HETE_COLUMN93, this.getHete_shifting_dullness());
		value.put(HETE_COLUMN94, this.getHete_lowerlimb_edema());
		value.put(HETE_COLUMN95, this.getHete_dorsalfoot_artetial_pulse());
		value.put(HETE_COLUMN96, this.getHete_anus());
		value.put(HETE_COLUMN97, this.getHete_anus_other());
		value.put(HETE_COLUMN98, this.getHete_mammary_gland());
		value.put(HETE_COLUMN99, this.getHete_mammary_gland_other());
		value.put(HETE_COLUMN100, this.getHete_vulva());
		value.put(HETE_COLUMN101, this.getHete_vulva_abnormal());
		value.put(HETE_COLUMN102, this.getHete_vagina());
		value.put(HETE_COLUMN103, this.getHete_vagina_abnormal());
		value.put(HETE_COLUMN104, this.getHete_cervix());
		value.put(HETE_COLUMN105, this.getHete_cervix_abnormal());
		value.put(HETE_COLUMN106, this.getHete_palace());
		value.put(HETE_COLUMN107, this.getHete_palace_abnormal());
		value.put(HETE_COLUMN108, this.getHete_appendix());
		value.put(HETE_COLUMN109, this.getHete_appendix_abnormal());
		value.put(HETE_COLUMN110, this.getHete_bodycheck_other());
		value.put(HETE_COLUMN111, this.getHete_hemoglobin());
		value.put(HETE_COLUMN112, this.getHete_wbc());
		value.put(HETE_COLUMN113, this.getHete_blood_platelet());
		value.put(HETE_COLUMN114, this.getHete_blood_other());
		value.put(HETE_COLUMN115, this.getHete_pro());
		value.put(HETE_COLUMN116, this.getHete_glu());
		value.put(HETE_COLUMN117, this.getHete_urine_ketone());
		value.put(HETE_COLUMN118, this.getHete_bld());
		value.put(HETE_COLUMN119, this.getHete_urine_other());
		value.put(HETE_COLUMN120, this.getHete_fbs1());
		value.put(HETE_COLUMN121, this.getHete_fbs2());
		value.put(HETE_COLUMN122, this.getHete_ecg());
		value.put(HETE_COLUMN123, this.getHete_ecg_abnormal());
		value.put(HETE_COLUMN124, this.getHete_uae());
		value.put(HETE_COLUMN125, this.getHete_fecal_occult_blood());
		value.put(HETE_COLUMN126, this.getHete_ghb());
		value.put(HETE_COLUMN127, this.getHete_hbsab());
		value.put(HETE_COLUMN128, this.getHete_serum_cpt());
		value.put(HETE_COLUMN129, this.getHete_serum_ast());
		value.put(HETE_COLUMN130, this.getHete_albumin());
		value.put(HETE_COLUMN131, this.getHete_tbil());
		value.put(HETE_COLUMN132, this.getHete_dbil());
		value.put(HETE_COLUMN133, this.getHete_serum_creatinine());
		value.put(HETE_COLUMN134, this.getHete_bun());
		value.put(HETE_COLUMN135, this.getHete_blood_k_chroma());
		value.put(HETE_COLUMN136, this.getHete_blood_na_chroma());
		value.put(HETE_COLUMN137, this.getHete_tc());
		value.put(HETE_COLUMN138, this.getHete_trig());
		value.put(HETE_COLUMN139, this.getHete_serum_ldlc());
		value.put(HETE_COLUMN140, this.getHete_serum_hdlc());
		value.put(HETE_COLUMN141, this.getHete_chest_x());
		value.put(HETE_COLUMN142, this.getHete_chest_x_abnormal());
		value.put(HETE_COLUMN143, this.getHete_brightness_mode());
		value.put(HETE_COLUMN144, this.getHete_brightness_mode_abnormal());
		value.put(HETE_COLUMN145, this.getHete_cervical_smear());
		value.put(HETE_COLUMN146, this.getHete_cervical_smear_abnormal());
		value.put(HETE_COLUMN147, this.getHete_assitest_other());
		value.put(HETE_COLUMN148, this.getHete_quality_pinghe());
		value.put(HETE_COLUMN149, this.getHete_quality_qixu());
		value.put(HETE_COLUMN150, this.getHete_quality_yangxu());
		value.put(HETE_COLUMN151, this.getHete_quality_yinxu());
		value.put(HETE_COLUMN152, this.getHete_quality_tanshi());
		value.put(HETE_COLUMN153, this.getHete_quality_shire());
		value.put(HETE_COLUMN154, this.getHete_quality_xueyu());
		value.put(HETE_COLUMN155, this.getHete_quality_qiyu());
		value.put(HETE_COLUMN156, this.getHete_quality_tebing());
		value.put(HETE_COLUMN157, this.getHete_cerebrovascul());
		value.put(HETE_COLUMN158, this.getHete_cerebrovascul_other());
		value.put(HETE_COLUMN159, this.getHete_kidney_disease());
		value.put(HETE_COLUMN160, this.getHete_kidney_disease_other());
		value.put(HETE_COLUMN161, this.getHete_heart_disease());
		value.put(HETE_COLUMN162, this.getHete_heart_disease_other());
		value.put(HETE_COLUMN163, this.getHete_vascular_disease());
		value.put(HETE_COLUMN164, this.getHete_vascular_disease_other());
		value.put(HETE_COLUMN165, this.getHete_eye_disease());
		value.put(HETE_COLUMN166, this.getHete_eye_disease_other());
		value.put(HETE_COLUMN167, this.getHete_has_neur_disease());
		value.put(HETE_COLUMN168, this.getHete_neur_disease());
		value.put(HETE_COLUMN169, this.getHete_has_other_system_disease());
		value.put(HETE_COLUMN170, this.getHete_other_system_disease());
		value.put(HETE_COLUMN171, this.getHete_ishealthtest_normal());
		value.put(HETE_COLUMN172, this.getHete_healthtest_abnormal());
		value.put(HETE_COLUMN173, this.getHete_healthguide());
		value.put(HETE_COLUMN174, this.getHete_hazard_control());
		value.put(HETE_COLUMN175, this.getHete_goal_of_lose_weight());
		value.put(HETE_COLUMN176, this.getHete_advical_vaccine());
		value.put(HETE_COLUMN177, this.getHete_other_hazard());
		
//		Uri uri = 
		mContext.getContentResolver().insert(CONTENT_URI_TB5, value);
//		result = getIdFromUri(uri);
//		return result;
		
	}
	
	/**
	 * 检出体检表，并实例化对象
	 * @param profileid 健康档案编号，建立档案时分配
	 * @param healthid 体检的次数
	 */
	public void selectHealthTest(int profileid, int healthid){
		
		String where = HETE_COLUMN1 + "=" + profileid + " AND "+HETE_COLUMN178 + "=" + healthid + "";
		Cursor cursor = mContext.getContentResolver().query(CONTENT_URI_TB5, null, where, null, null);
		while(cursor.moveToNext()){
		this.hete_profileid = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN1));
		this.hete_testid = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN178));
		this.hete_date = cursor.getString(cursor.getColumnIndex(HETE_COLUMN2));
		this.hete_doctor = cursor.getString(cursor.getColumnIndex(HETE_COLUMN3));
		this.hete_symptom = cursor.getString(cursor.getColumnIndex(HETE_COLUMN4));
		this.hete_symptom_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN5));
		this.hete_body_temperature = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN6));
		this.hete_pulse_rate = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN7));
		this.hete_respiratory_rate = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN8));
		this.hete_bloodpressure_left_high = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN9));
		this.hete_bloodpressure_left_low = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN10));
		this.hete_bloodpressure_right_high = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN11));
		this.hete_bloodpressure_right_low = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN12));
		this.hete_height = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN13));
		this.hete_weight = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN14));
		this.hete_waistline = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN15));
		this.hete_bmt = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN16));
		this.hete_olds_health = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN17));
		this.hete_olds_selfcare = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN18));
		this.hete_olds_cognition = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN19));
		this.hete_olds_intelligence = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN20));
		this.hete_olds_emotion = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN21));
		this.hete_olds_depression = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN22));
		this.hete_exercise_fq = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN23));
		this.hete_exercise_per_time = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN24));
		this.hete_exercise_lastlong = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN25));
		this.hete_exercise_method = cursor.getString(cursor.getColumnIndex(HETE_COLUMN26));
		this.hete_diet_habit = cursor.getString(cursor.getColumnIndex(HETE_COLUMN27));
		this.hete_smoke = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN28));
		this.hete_smoke_per_day = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN29));
		this.hete_smoke_startage = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN30));
		this.hete_smoke_quitage = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN31));
		this.hete_drink_fq = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN32));
		this.hete_drink_per_day = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN33));
		this.hete_is_abstinent = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN34));
		this.hete_abstent_age = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN35));
		this.hete_drink_startage = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN36));
		this.hete_recent_alcoholism = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN37));
		this.hete_drink_sorts = cursor.getString(cursor.getColumnIndex(HETE_COLUMN38));
		this.hete_drink_other_sort = cursor.getString(cursor.getColumnIndex(HETE_COLUMN39));
		this.hete_has_occupational_hazards = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN40));
		this.hete_occupation = cursor.getString(cursor.getColumnIndex(HETE_COLUMN41));
		this.hete_work_time = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN42));
		this.hete_dust = cursor.getString(cursor.getColumnIndex(HETE_COLUMN43));
		this.hete_dust_has_defence = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN44));
		this.hete_dust_defence = cursor.getString(cursor.getColumnIndex(HETE_COLUMN45));
		this.hete_radiation = cursor.getString(cursor.getColumnIndex(HETE_COLUMN46));
		this.hete_radiation_has_defence = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN47));
		this.hete_radiaiton_defence = cursor.getString(cursor.getColumnIndex(HETE_COLUMN48));
		this.hete_physics = cursor.getString(cursor.getColumnIndex(HETE_COLUMN49));
		this.hete_physics_has_defence = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN50));
		this.hete_physics_defence = cursor.getString(cursor.getColumnIndex(HETE_COLUMN51));
		this.hete_chemistry = cursor.getString(cursor.getColumnIndex(HETE_COLUMN52));
		this.hete_chemistry_has_defence = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN53));
		this.hete_chemistry_defence = cursor.getString(cursor.getColumnIndex(HETE_COLUMN54));
		this.hete_other_toxic = cursor.getString(cursor.getColumnIndex(HETE_COLUMN55));
		this.hete_other_toxic_has_defence = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN56));
		this.hete_other_toxic_defence = cursor.getString(cursor.getColumnIndex(HETE_COLUMN57));
		this.hete_lips = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN58));
		this.hete_teeth = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN59));
		this.hete_throat = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN60));
		this.hete_eyesight_left = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN61));
		this.hete_eyesight_right = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN62));
		this.hete_correct_eyesight_left = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN63));
		this.hete_correct_eyesight_right = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN64));
		this.hete_hearing = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN65));
		this.hete_motion_funtion = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN66));
		this.hete_eyeground_isnormal = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN67));
		this.hete_eyeground_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN68));
		this.hete_skin = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN69));
		this.hete_skin_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN70));
		this.hete_sclera = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN71));
		this.hete_sclera_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN72));
		this.hete_lymphnode = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN73));
		this.hete_lymphnode_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN74));
		this.hete_barrelchest = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN75));
		this.hete_breathsound_isnormal = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN76));
		this.hete_breathsound_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN77));
		this.hete_rale = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN78));
		this.hete_rale_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN79));
		this.hete_heartrate = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN80));
		this.hete_heart_rhythm = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN81));
		this.hete_has_heart_murmurs = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN82));
		this.hete_heart_murmurs = cursor.getString(cursor.getColumnIndex(HETE_COLUMN83));
		this.hete_has_tenderness = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN84));
		this.hete_tenderness = cursor.getString(cursor.getColumnIndex(HETE_COLUMN85));
		this.hete_has_mess = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN86));
		this.hete_mess = cursor.getString(cursor.getColumnIndex(HETE_COLUMN87));
		this.hete_has_hepatomegalia = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN88));
		this.hete_hepatomegalia = cursor.getString(cursor.getColumnIndex(HETE_COLUMN89));
		this.hete_has_splenoma = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN90));
		this.hete_splenoma = cursor.getString(cursor.getColumnIndex(HETE_COLUMN91));
		this.hete_has_shifting_dullness = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN92));
		this.hete_shifting_dullness = cursor.getString(cursor.getColumnIndex(HETE_COLUMN93));
		this.hete_lowerlimb_edema = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN94));
		this.hete_dorsalfoot_artetial_pulse = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN95));
		this.hete_anus = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN96));
		this.hete_anus_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN97));
		this.hete_mammary_gland = cursor.getString(cursor.getColumnIndex(HETE_COLUMN98));
		this.hete_mammary_gland_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN99));
		this.hete_vulva = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN100));
		this.hete_vulva_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN101));
		this.hete_vagina = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN102));
		this.hete_vagina_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN103));
		this.hete_cervix = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN104));
		this.hete_cervix_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN105));
		this.hete_palace = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN106));
		this.hete_palace_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN107));
		this.hete_appendix = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN108));
		this.hete_appendix_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN109));
		this.hete_bodycheck_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN110));
		this.hete_hemoglobin = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN111));
		this.hete_wbc = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN112));
		this.hete_blood_platelet = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN113));
		this.hete_blood_other = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN114));
		this.hete_pro = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN115));
		this.hete_glu = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN116));
		this.hete_urine_ketone = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN117));
		this.hete_bld = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN118));
		this.hete_urine_other = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN119));
		this.hete_fbs1 = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN120));
		this.hete_fbs2 = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN121));
		this.hete_ecg = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN122));
		this.hete_ecg_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN123));
		this.hete_uae = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN124));
		this.hete_fecal_occult_blood = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN125));
		this.hete_ghb = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN126));
		this.hete_hbsab = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN127));
		this.hete_serum_cpt = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN128));
		this.hete_serum_ast = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN129));
		this.hete_albumin = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN130));
		this.hete_tbil = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN131));
		this.hete_dbil = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN132));
		this.hete_serum_creatinine = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN133));
		this.hete_bun = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN134));
		this.hete_blood_k_chroma = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN135));
		this.hete_blood_na_chroma = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN136));
		this.hete_tc = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN137));
		this.hete_trig = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN138));
		this.hete_serum_ldlc = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN139));
		this.hete_serum_hdlc = cursor.getFloat(cursor.getColumnIndex(HETE_COLUMN140));
		this.hete_chest_x = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN141));
		this.hete_chest_x_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN142));
		this.hete_brightness_mode = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN143));
		this.hete_brightness_mode_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN144));
		this.hete_cervical_smear = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN145));
		this.hete_cervical_smear_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN146));
		this.hete_assitest_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN147));
		this.hete_quality_pinghe = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN148));
		this.hete_quality_qixu = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN149));
		this.hete_quality_yangxu = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN150));
		this.hete_quality_yinxu = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN151));
		this.hete_quality_tanshi = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN152));
		this.hete_quality_shire = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN153));
		this.hete_quality_xueyu = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN154));
		this.hete_quality_qiyu = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN155));
		this.hete_quality_tebing = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN156));
		this.hete_cerebrovascul = cursor.getString(cursor.getColumnIndex(HETE_COLUMN157));
		this.hete_cerebrovascul_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN158));
		this.hete_kidney_disease = cursor.getString(cursor.getColumnIndex(HETE_COLUMN159));
		this.hete_kidney_disease_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN160));
		this.hete_heart_disease = cursor.getString(cursor.getColumnIndex(HETE_COLUMN161));
		this.hete_heart_disease_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN162));
		this.hete_vascular_disease = cursor.getString(cursor.getColumnIndex(HETE_COLUMN163));
		this.hete_vascular_disease_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN164));
		this.hete_eye_disease = cursor.getString(cursor.getColumnIndex(HETE_COLUMN165));
		this.hete_eye_disease_other = cursor.getString(cursor.getColumnIndex(HETE_COLUMN166));
		this.hete_has_neur_disease = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN167));
		this.hete_neur_disease = cursor.getString(cursor.getColumnIndex(HETE_COLUMN168));
		this.hete_has_other_system_disease = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN169));
		this.hete_other_system_disease = cursor.getString(cursor.getColumnIndex(HETE_COLUMN170));
		this.hete_ishealthtest_normal = cursor.getInt(cursor.getColumnIndex(HETE_COLUMN171));
		this.hete_healthtest_abnormal = cursor.getString(cursor.getColumnIndex(HETE_COLUMN172));
		this.hete_healthguide = cursor.getString(cursor.getColumnIndex(HETE_COLUMN173));
		this.hete_hazard_control = cursor.getString(cursor.getColumnIndex(HETE_COLUMN174));
		this.hete_goal_of_lose_weight = cursor.getString(cursor.getColumnIndex(HETE_COLUMN175));
		this.hete_advical_vaccine = cursor.getString(cursor.getColumnIndex(HETE_COLUMN176));
		this.hete_other_hazard = cursor.getString(cursor.getColumnIndex(HETE_COLUMN177));
		}
		cursor.close();
	}
	
	/**
	 * 更新体检表，并实例化对象
	 * @param profileid 健康档案编号，建立档案时分配
	 * @param healthid 体检的次数
	 */
	public void updateHealthTest(int profileid,int healthid){
		ContentValues value = new ContentValues();
		value.put(HETE_COLUMN1, this.getHete_profileid());
		value.put(HETE_COLUMN178, this.getHete_testid());
		value.put(HETE_COLUMN2, this.getHete_date());
		value.put(HETE_COLUMN3, this.getHete_doctor());
		value.put(HETE_COLUMN4, this.getHete_symptom());
		value.put(HETE_COLUMN5, this.getHete_symptom_other());
		value.put(HETE_COLUMN6, this.getHete_body_temperature());
		value.put(HETE_COLUMN7, this.getHete_pulse_rate());
		value.put(HETE_COLUMN8, this.getHete_respiratory_rate());
		value.put(HETE_COLUMN9, this.getHete_bloodpressure_left_high());
		value.put(HETE_COLUMN10, this.getHete_bloodpressure_left_low());
		value.put(HETE_COLUMN11, this.getHete_bloodpressure_right_high());
		value.put(HETE_COLUMN12, this.getHete_bloodpressure_right_low());
		value.put(HETE_COLUMN13, this.getHete_height());
		value.put(HETE_COLUMN14, this.getHete_weight());
		value.put(HETE_COLUMN15, this.getHete_waistline());
		value.put(HETE_COLUMN16, this.getHete_bmt());
		value.put(HETE_COLUMN17, this.getHete_olds_health());
		value.put(HETE_COLUMN18, this.getHete_olds_selfcare());
		value.put(HETE_COLUMN19, this.getHete_olds_cognition());
		value.put(HETE_COLUMN20, this.getHete_olds_intelligence());
		value.put(HETE_COLUMN21, this.getHete_olds_emotion());
		value.put(HETE_COLUMN22, this.getHete_olds_depression());
		value.put(HETE_COLUMN23, this.getHete_exercise_fq());
		value.put(HETE_COLUMN24, this.getHete_exercise_per_time());
		value.put(HETE_COLUMN25, this.getHete_exercise_lastlong());
		value.put(HETE_COLUMN26, this.getHete_exercise_method());
		value.put(HETE_COLUMN27, this.getHete_diet_habit());
		value.put(HETE_COLUMN28, this.getHete_smoke());
		value.put(HETE_COLUMN29, this.getHete_smoke_per_day());
		value.put(HETE_COLUMN30, this.getHete_smoke_startage());
		value.put(HETE_COLUMN31, this.getHete_smoke_quitage());
		value.put(HETE_COLUMN32, this.getHete_drink_fq());
		value.put(HETE_COLUMN33, this.getHete_drink_per_day());
		value.put(HETE_COLUMN34, this.getHete_is_abstinent());
		value.put(HETE_COLUMN35, this.getHete_abstent_age());
		value.put(HETE_COLUMN36, this.getHete_drink_startage());
		value.put(HETE_COLUMN37, this.getHete_recent_alcoholism());
		value.put(HETE_COLUMN38, this.getHete_drink_sorts());
		value.put(HETE_COLUMN39, this.getHete_drink_other_sort());
		value.put(HETE_COLUMN40, this.getHete_has_occupational_hazards());
		value.put(HETE_COLUMN41, this.getHete_occupation());
		value.put(HETE_COLUMN42, this.getHete_work_time());
		value.put(HETE_COLUMN43, this.getHete_dust());
		value.put(HETE_COLUMN44, this.getHete_dust_has_defence());
		value.put(HETE_COLUMN45, this.getHete_dust_defence());
		value.put(HETE_COLUMN46, this.getHete_radiation());
		value.put(HETE_COLUMN47, this.getHete_radiation_has_defence());
		value.put(HETE_COLUMN48, this.getHete_radiaiton_defence());
		value.put(HETE_COLUMN49, this.getHete_physics());
		value.put(HETE_COLUMN50, this.getHete_physics_has_defence());
		value.put(HETE_COLUMN51, this.getHete_physics_defence());
		value.put(HETE_COLUMN52, this.getHete_chemistry());
		value.put(HETE_COLUMN53, this.getHete_chemistry_has_defence());
		value.put(HETE_COLUMN54, this.getHete_chemistry_defence());
		value.put(HETE_COLUMN55, this.getHete_other_toxic());
		value.put(HETE_COLUMN56, this.getHete_other_toxic_has_defence());
		value.put(HETE_COLUMN57, this.getHete_other_toxic_defence());
		value.put(HETE_COLUMN58, this.getHete_lips());
		value.put(HETE_COLUMN59, this.getHete_teeth());
		value.put(HETE_COLUMN60, this.getHete_throat());
		value.put(HETE_COLUMN61, this.getHete_eyesight_left());
		value.put(HETE_COLUMN62, this.getHete_eyesight_right());
		value.put(HETE_COLUMN63, this.getHete_correct_eyesight_left());
		value.put(HETE_COLUMN64, this.getHete_correct_eyesight_right());
		value.put(HETE_COLUMN65, this.getHete_hearing());
		value.put(HETE_COLUMN66, this.getHete_motion_funtion());
		value.put(HETE_COLUMN67, this.getHete_eyeground_isnormal());
		value.put(HETE_COLUMN68, this.getHete_eyeground_abnormal());
		value.put(HETE_COLUMN69, this.getHete_skin());
		value.put(HETE_COLUMN70, this.getHete_skin_other());
		value.put(HETE_COLUMN71, this.getHete_sclera());
		value.put(HETE_COLUMN72, this.getHete_sclera_other());
		value.put(HETE_COLUMN73, this.getHete_lymphnode());
		value.put(HETE_COLUMN74, this.getHete_lymphnode_other());
		value.put(HETE_COLUMN75, this.getHete_barrelchest());
		value.put(HETE_COLUMN76, this.getHete_breathsound_isnormal());
		value.put(HETE_COLUMN77, this.getHete_breathsound_abnormal());
		value.put(HETE_COLUMN78, this.getHete_rale());
		value.put(HETE_COLUMN79, this.getHete_rale_other());
		value.put(HETE_COLUMN80, this.getHete_heartrate());
		value.put(HETE_COLUMN81, this.getHete_heart_rhythm());
		value.put(HETE_COLUMN82, this.getHete_has_heart_murmurs());
		value.put(HETE_COLUMN83, this.getHete_heart_murmurs());
		value.put(HETE_COLUMN84, this.getHete_has_tenderness());
		value.put(HETE_COLUMN85, this.getHete_tenderness());
		value.put(HETE_COLUMN86, this.getHete_has_mess());
		value.put(HETE_COLUMN87, this.getHete_mess());
		value.put(HETE_COLUMN88, this.getHete_has_hepatomegalia());
		value.put(HETE_COLUMN89, this.getHete_hepatomegalia());
		value.put(HETE_COLUMN90, this.getHete_has_splenoma());
		value.put(HETE_COLUMN91, this.getHete_splenoma());
		value.put(HETE_COLUMN92, this.getHete_has_shifting_dullness());
		value.put(HETE_COLUMN93, this.getHete_shifting_dullness());
		value.put(HETE_COLUMN94, this.getHete_lowerlimb_edema());
		value.put(HETE_COLUMN95, this.getHete_dorsalfoot_artetial_pulse());
		value.put(HETE_COLUMN96, this.getHete_anus());
		value.put(HETE_COLUMN97, this.getHete_anus_other());
		value.put(HETE_COLUMN98, this.getHete_mammary_gland());
		value.put(HETE_COLUMN99, this.getHete_mammary_gland_other());
		value.put(HETE_COLUMN100, this.getHete_vulva());
		value.put(HETE_COLUMN101, this.getHete_vulva_abnormal());
		value.put(HETE_COLUMN102, this.getHete_vagina());
		value.put(HETE_COLUMN103, this.getHete_vagina_abnormal());
		value.put(HETE_COLUMN104, this.getHete_cervix());
		value.put(HETE_COLUMN105, this.getHete_cervix_abnormal());
		value.put(HETE_COLUMN106, this.getHete_palace());
		value.put(HETE_COLUMN107, this.getHete_palace_abnormal());
		value.put(HETE_COLUMN108, this.getHete_appendix());
		value.put(HETE_COLUMN109, this.getHete_appendix_abnormal());
		value.put(HETE_COLUMN110, this.getHete_bodycheck_other());
		value.put(HETE_COLUMN111, this.getHete_hemoglobin());
		value.put(HETE_COLUMN112, this.getHete_wbc());
		value.put(HETE_COLUMN113, this.getHete_blood_platelet());
		value.put(HETE_COLUMN114, this.getHete_blood_other());
		value.put(HETE_COLUMN115, this.getHete_pro());
		value.put(HETE_COLUMN116, this.getHete_glu());
		value.put(HETE_COLUMN117, this.getHete_urine_ketone());
		value.put(HETE_COLUMN118, this.getHete_bld());
		value.put(HETE_COLUMN119, this.getHete_urine_other());
		value.put(HETE_COLUMN120, this.getHete_fbs1());
		value.put(HETE_COLUMN121, this.getHete_fbs2());
		value.put(HETE_COLUMN122, this.getHete_ecg());
		value.put(HETE_COLUMN123, this.getHete_ecg_abnormal());
		value.put(HETE_COLUMN124, this.getHete_uae());
		value.put(HETE_COLUMN125, this.getHete_fecal_occult_blood());
		value.put(HETE_COLUMN126, this.getHete_ghb());
		value.put(HETE_COLUMN127, this.getHete_hbsab());
		value.put(HETE_COLUMN128, this.getHete_serum_cpt());
		value.put(HETE_COLUMN129, this.getHete_serum_ast());
		value.put(HETE_COLUMN130, this.getHete_albumin());
		value.put(HETE_COLUMN131, this.getHete_tbil());
		value.put(HETE_COLUMN132, this.getHete_dbil());
		value.put(HETE_COLUMN133, this.getHete_serum_creatinine());
		value.put(HETE_COLUMN134, this.getHete_bun());
		value.put(HETE_COLUMN135, this.getHete_blood_k_chroma());
		value.put(HETE_COLUMN136, this.getHete_blood_na_chroma());
		value.put(HETE_COLUMN137, this.getHete_tc());
		value.put(HETE_COLUMN138, this.getHete_trig());
		value.put(HETE_COLUMN139, this.getHete_serum_ldlc());
		value.put(HETE_COLUMN140, this.getHete_serum_hdlc());
		value.put(HETE_COLUMN141, this.getHete_chest_x());
		value.put(HETE_COLUMN142, this.getHete_chest_x_abnormal());
		value.put(HETE_COLUMN143, this.getHete_brightness_mode());
		value.put(HETE_COLUMN144, this.getHete_brightness_mode_abnormal());
		value.put(HETE_COLUMN145, this.getHete_cervical_smear());
		value.put(HETE_COLUMN146, this.getHete_cervical_smear_abnormal());
		value.put(HETE_COLUMN147, this.getHete_assitest_other());
		value.put(HETE_COLUMN148, this.getHete_quality_pinghe());
		value.put(HETE_COLUMN149, this.getHete_quality_qixu());
		value.put(HETE_COLUMN150, this.getHete_quality_yangxu());
		value.put(HETE_COLUMN151, this.getHete_quality_yinxu());
		value.put(HETE_COLUMN152, this.getHete_quality_tanshi());
		value.put(HETE_COLUMN153, this.getHete_quality_shire());
		value.put(HETE_COLUMN154, this.getHete_quality_xueyu());
		value.put(HETE_COLUMN155, this.getHete_quality_qiyu());
		value.put(HETE_COLUMN156, this.getHete_quality_tebing());
		value.put(HETE_COLUMN157, this.getHete_cerebrovascul());
		value.put(HETE_COLUMN158, this.getHete_cerebrovascul_other());
		value.put(HETE_COLUMN159, this.getHete_kidney_disease());
		value.put(HETE_COLUMN160, this.getHete_kidney_disease_other());
		value.put(HETE_COLUMN161, this.getHete_heart_disease());
		value.put(HETE_COLUMN162, this.getHete_heart_disease_other());
		value.put(HETE_COLUMN163, this.getHete_vascular_disease());
		value.put(HETE_COLUMN164, this.getHete_vascular_disease_other());
		value.put(HETE_COLUMN165, this.getHete_eye_disease());
		value.put(HETE_COLUMN166, this.getHete_eye_disease_other());
		value.put(HETE_COLUMN167, this.getHete_has_neur_disease());
		value.put(HETE_COLUMN168, this.getHete_neur_disease());
		value.put(HETE_COLUMN169, this.getHete_has_other_system_disease());
		value.put(HETE_COLUMN170, this.getHete_other_system_disease());
		value.put(HETE_COLUMN171, this.getHete_ishealthtest_normal());
		value.put(HETE_COLUMN172, this.getHete_healthtest_abnormal());
		value.put(HETE_COLUMN173, this.getHete_healthguide());
		value.put(HETE_COLUMN174, this.getHete_hazard_control());
		value.put(HETE_COLUMN175, this.getHete_goal_of_lose_weight());
		value.put(HETE_COLUMN176, this.getHete_advical_vaccine());
		value.put(HETE_COLUMN177, this.getHete_other_hazard());
		
		String where = HETE_COLUMN1 + "=" + profileid + " and "+HETE_COLUMN178 + "=" + healthid + "";
//		String where = HETE_COLUMN1 + "=" + id + "";
		mContext.getContentResolver().update(CONTENT_URI_TB5, value, where, null);
		System.out.println("update "+this.getHete_testid()+"th HealthTest");
	}
	
	/**
	 * 删除患者的某次体检表
	 * @param profileid 健康档案编号，建立档案时分配
	 * @param healthid 体检的次数
	 */
	public void delectHealthTest(int profileid,int healthid){
		String where = HETE_COLUMN1 + "=" + profileid + " and "+HETE_COLUMN178 + "=" + healthid + "";
		mContext.getContentResolver().delete(CONTENT_URI_TB5,where, null);
		
	}
	
	/**
	 * 删除患者的全部体检表
	 * @param profileid 健康档案编号
	 */
	public void delectHealthTest(int profileid){
		String where = HETE_COLUMN1 + "=" + profileid + "";
		mContext.getContentResolver().delete(CONTENT_URI_TB5,where, null);
		
	}
	
	
	/**
	 * 用户体检表的个数，新建时times+=1
	 */
	public int getHealthTestTimes(int profileid){ 
		int result = 0;
		String where = HETE_COLUMN1 + "=" + profileid + "";
		Cursor cursor = mContext.getContentResolver().query(CONTENT_URI_TB5, null, where, null, null);
		result = cursor.getCount();
		cursor.close();
		return result;
	}
}
